<?php
// Content
$query = "SELECT t.id, tc.title FROM tours t JOIN tour_content tc ON tc.tour_id = t.id WHERE t.status = 1 ORDER BY t.id";
$data = $db->getData(null, $query);
if (is_array($data) && count($data)) {
	for ($i=0; $i<count($data); $i++) {
		$data[$i]["editUrl"] = Utils::generateSEOUrl($lang, $section, "edit", $data[$i]["id"]);
	}
}
$content->assign("data", $data);
?>
